Introduction
The purpose of this document is to consolidate and review the CTD Rosette data collected during the ASPIRE campaign. In Step 1, The data are downloaded from the data landing pages and the file paths are reviewed. In Step 2, the file types are counted and compared to what is recorded in the ASPIRE data inventory. Step 3 runs a QAQC check on the spatial data provided in the CTD files. Steps 4 and 5 compute summary statistics for each sensor used on each cast, creates boxplots for each cast depth, and profile plots for each sensor.
The ASPIRE campaign was conducted from 2018 to 2022. The information presented here is from Okeanos Explorer CTD Rosette data collected in the following regions: SOUTH ATLANTIC BIGHT, CARIBBEAN, SOUTHEAST US, NORTHEAST U.S. & CANADA, No Record, Puerto Rico.
Step 1: Download the CTD Rosette files
Table 1. File paths for CTD Rosette data downloaded from data Landing Pages . The function that creates this table downloads all of the Shipboard CTD data from the DLPs, looks for the presence key folders (“Profile_Data,”CTD”, and “SHIPCTD”), and documents the file paths to each dataset. The goal is for all file paths to be identical.
After creating table 1, manually fix file paths and rerun to see results (optional).
Table 2. File paths for CTD Rosette data downloaded from Data Landing Pages (DLP) with updates.
Step 2: Count and compare
Table 3. Comparison of .hex and .cnv files for each expedition with the ASPIRE data inventory.
If possible, use Seabird SeaTerm software (https://www.seabird.com/software) to convert the hex files to cnv files where missing and rerun the table above. At this point you can determine which expedition folders are missing CTD Rosette files. Follow up with NCEI to get files.
Step 3: Check latitude and longitude
Do all casts have latitude and longitude in the metadata?
Table 4. CTD Rosette casts without latitude and longitude in the metadata.
Map all casts locations
Fig. 1. Map of all CTD Rosette cast locations colored by expedition. See table 4 for expeditions and cast missing latitude and longitude and therefore not included on the map.
Step 4: Run summary statistics.
Table 5. Summary statistics for each sensor used on each cast. Blank cells indicate the sensor was not in use.